home *** CD-ROM | disk | FTP | other *** search
/ PC Answers 1995 May / PC Answers CD-ROM 7 (Future Publishing) (May 1995).iso / vbits / code / cert / trk3_eg / sql_data / sql1 / pubs.frm (.txt) next >
Encoding:
Visual Basic Form  |  1994-09-15  |  1.8 KB  |  49 lines
  1. Form1
  2. SQL using Data Control to Pubs
  3. Form15
  4. cmdMove
  5. E&xit
  6. cmdMove
  7. &Find
  8. cmdMove
  9. &Last
  10. cmdMove
  11. &First
  12. cmdMove
  13.     &Previous
  14. cmdMove
  15. &Next
  16. txtLName
  17. Data1*
  18. au_lname
  19. txtTitle
  20. Data1*
  21. title
  22. Data1%
  23. )ODBC;DSN=MySQL;Database=pubs;UID=SA;PWD=;
  24. dbo.authors
  25. SQL Pubs Example
  26. lblLName
  27. Author's Last Name
  28. lblTitle
  29. Title
  30. cmdMove_Click
  31. index
  32. Data1
  33.     Recordset
  34. @    Form_Load
  35. RecordSource
  36. criteria
  37. NoMatch
  38. Found
  39. bookmark
  40. currentrec
  41. cmdMove_Click
  42. Enter last name of employee to find
  43. Find Box
  44. au_lname Like 
  45. No Record Found!
  46. Not Found
  47. Form_Load
  48. Select au_lname, title from authors, titles, titleauthor where titleauthor.au_id = authors.au_id and titleauthor.title_id = titles.title_id
  49.